-
Re: INDEX and MATCH across two sheets: a detailed explanation
@Nick Stamatakis - I haven't touched Smartsheet in like 2 years; just happened to login today. Hi. Glad my post was helpful. What you're looking to do is an interesting use case, which I will refer t…1 · -
Re: INDEX and MATCH across two sheets: a detailed explanation
Create some references on the 'new' sheet to the 'original' sheet So, first things first, let's create some References. Go to the "Companies_Public" Sheet. Right click any cell, and press &…6 · -
Re: Countif with OR referencing multiple sheets
Hey Kendra! Thanks for posting your formula as text and not as a screenshot, that helps a lot! I don't believe you need the OR function for what you're wanting. You just want a total # of "Close…1 · -
Re: INDEX and MATCH across two sheets: a detailed explanation
Example: A Tale of Two Sheets For this example, we'll have 2 sheets that have the same info on each, minus one column on the "Public" sheet. The first sheet we will call "Companies_Pri…5 · -
INDEX and MATCH across two sheets: a detailed explanation
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to th…15 ·